package com.cn.serverline.lineicp.workshopPlan.entity.request;

import cn.stylefeng.roses.kernel.rule.annotation.ChineseDescription;
import com.alibaba.excel.annotation.ExcelIgnore;
import com.alibaba.excel.annotation.ExcelProperty;
import com.alibaba.excel.annotation.write.style.ColumnWidth;
import com.alibaba.excel.annotation.write.style.HeadRowHeight;
import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import lombok.EqualsAndHashCode;

/**
 *
 * 滚动计划 导入模板
 * @author pty
 * @since 2023-12-11
 */
@Data
@EqualsAndHashCode
@HeadRowHeight(55)
@ColumnWidth(23)
public class RollingDetailExcel {
    /**
     * 产品型号
     */
    @ExcelProperty(value = {"产品型号"},index = 0)
    private String productModel;

    /**
     * 产品型号状态
     */
    @ChineseDescription("类型")
    @ExcelProperty(value = {"类型"},index = 1)
    private String modelState;

    /**
     * 月份
     */
    @ExcelProperty(value = {"T月份\r\n(yyyy年mm月)"},index = 2)
    private String rollingMonth;

    /**
     * 来源:集团
     */
    @ChineseDescription("来源:集团")
    @ExcelProperty(value = {"T月","来源:集团"},index = 3)
    private Long sourceGroup;

    /**
     * 来源:机载
     */
    @ChineseDescription("来源:机载")
    @ExcelProperty(value = {"T月","来源:机载"},index = 4)
    private Long sourceAirborne;

    /**
     * 来源:航材
     */
    @ChineseDescription("来源:航材")
    @ExcelProperty(value = {"T月","来源:航材"},index = 5)
    private Long sourceAviation;

    @ChineseDescription("计划类别")
    @ExcelProperty(value = {"T月","计划类别"},index = 6)
    private String planCategory;

    /**
     * 计划交付数量
     */
    @ChineseDescription("计划交付数量")
    @ExcelProperty(value = {"T月","计划交付数量"},index = 7)
    private Long deliveryQuantity;

    /**
     * 交付日期
     */
    @ChineseDescription("交付日期")
    @ExcelProperty(value = {"T月","交付日期\r\n(yyyy年mm月dd日)"},index = 8)
    private String deliveryDate;

    /**
     * 计划交付数量
     */
    @ExcelProperty(value = {"T+1月份","计划交付数量"},index = 9)
    private Long oneDeliveryQuantity;

    /**
     * 交付日期
     */
    @ExcelProperty(value = {"T+1月份","交付日期\r\n(yyyy年mm月dd日)"},index = 10)
    private String oneDeliveryDate;


    /**
     * 交付日期
     */
    @ExcelIgnore
    private String twoDeliveryDate;

    /**
     * 工段id
     */
    @JsonFormat(shape = JsonFormat.Shape.STRING)
    @ExcelIgnore
    private Long planWorkSectionId;

    /**
     * 产品型号id
     */
    @ExcelIgnore
    private Long MstProductId;

    /**
     * 产品型号状态code
     */
    @ExcelIgnore
    private Long productModelState;

}
